Warehouse Management Tables

Note: Rows and/or Tables marked with an asterisk (*) are added to Traverse Global. Rows and/or Tables marked with a negative asterisk (-*) refer to tables and/or rows that are removed in Traverse Global.

Column Name Column Type Length Default Value Description Enumeration
BOLDtlRef int 4      
BOLRef int 4      
Source tinyint 1 0 Source 0 = Manual Entry, 1 = SO Trans
TransId pTransID 8      
EntryNum int 4      
Descr nvarchar 35      
Qty pDecimal 13      
QtyUOM pUom 5      
HandleQty pDecimal 13 0    
HandleUOM pUom 5      
ExtWeight pDecimal 13 0    
RateClass nvarchar 7      
HazMatYn bit 1 0    
NMFCNo nvarchar 10      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BOLDtlOrderRef int 4      
BOLRef int 4      
Source tinyint 1 0 Source 0 = Manual Entry, 1 = SO Trans
CustomerPoNo nvarchar 25      
PackQty pDecimal 13      
ExtWeight pDecimal 13      
PalletSlipYn bit 1 0    
AddnlShipperInfo nvarchar 60      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BOLHMRef int 4      
BOLDtlRef int 4      
HMCode nvarchar 6      
Descr nvarchar 300      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
BOLRef int 4      
BOLNum nvarchar 17      
ShipDate datetime 8 getdate()    
ShipFromId pLocID 10      
ShipFromName nvarchar 35      
ShipFromAddr1 nvarchar 30      
ShipFromAddr2 nvarchar 60      
ShipFromCity nvarchar 30      
ShipFromRegion nvarchar 10      
ShipFromCountry pCountry 6      
ShipFromPostalCode nvarchar 10      
ShipFromFOBYn bit 1 0    
SIDNumber pInvoiceNum 15      
ShipToId pCustID 10      
ShipToName nvarchar 30      
ShipToAddr1 nvarchar 30      
ShipToAddr2 nvarchar 60      
ShipToCity nvarchar 30      
ShipToRegion nvarchar 10      
ShipToCountry pCountry 6      
ShipToPostalCode nvarchar 10      
ShipToFOBYn bit 1 0    
ShipToLocNo nvarchar 10      
CIDNumber pInvoiceNum 15      
BillToId pCustID 10      
BillToName nvarchar 30      
BillToAddr1 nvarchar 30      
BillToAddr2 nvarchar 60      
BillToCity nvarchar 30      
BillToRegion nvarchar 10      
BillToCountry pCountry 6      
BillToPostalCode nvarchar 10      
CarrierName nvarchar 30      
CarrierSCAC nvarchar 4      
CarrierPRO nvarchar 20      
VehicleNumber nvarchar 16      
SealNumber nvarchar 16      
CODFeeType tinyint 1 0 COD Fee Type 0 = Collect, 1 = Prepaid
CODAmount pDecimal 13 0    
FreightFeeType tinyint 1 0 Freight Fee Type 0 = Prepaid, 1 = Collect, 2 = 3rd Party
EmergencyPhone nvarchar 20      
EmergencyEXT nvarchar 6      
DeclaredValue pDecimal 13 0    
DeclaredValueUnit nvarchar 8      
CustId pCustID 10      
SpecialInst varchar max      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
LocID pLoc 2      
CountType tinyint 1 0   0 = ABC Class, 1 = Bin, 2 = Random Bin
CountPerYear int   0    
CountDaysPerYear int   0    
MaxNumOfItems int   0    
ItemsWithNoHistYn bit 1 0    
FreezeYn bit 1 0    
Filter nvarchar max      
DisplayFilter nvarchar max      
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
LocID pLoc 2      
CountType tinyint 1 0   0 = ABC Class, 1 = Bin, 2 = Random Bin
NumOfItems int   0    
NumOfItemsCounted int   0    
Filter nvarchar max      
DisplayFilter nvarchar max      
BatchID pBatchID        
BatchDescr nvarchar 50      
CountDate datetime 8      
AssignedTo pEmpID        
PreparedDateTime datetime 8      
PreparedBy pUserID        
FrozenDateTime datetime 8      
FrozenBy pUserID        
PostRun pPostRun        
ts timestamp 8      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Descr varchar 25      
ExtLocID varchar 10      
Id int 4      
LocID pLocID 10      
ts timestamp 8      
Type smallint 2   Type 0 = Bin(A), 1 = Container(B)
CF xml -1      
*ZoneID nvarchar 10      
*ExtLocTypeID tinyint 2 0    
Column Name Column Type Length Default Value Description Enumeration
Id tinyint 2      
Description pDescription 25      
AvailableYN bit 1      
ts timestamp 8      
CF xml -1      
*ExtLocARef integer        
Column Name Column Type Length Default Value Description Enumeration
ExtHistSeqNum int 4      
HistSeqNum int 4      
HistSeqNumSer int 4      
ItemId pItemID 24      
LocId pLocID 10      
Lotnum pLotNum 16      
Sernum pSerNum 35      
ExtLocA int 4      
ExtLocAID nvarchar 10      
ExtLocB int 4      
ExtLocBID nvarchar 10      
Source tinyint 2      
-*TransId pTransID 8      
*TransId nvarchar 255      
EntryNum int 4      
ReferenceId pInvoiceNum 15      
EntryDate datetime 8 getdate()    
TransDate datetime 8      
Qty pDecimal 13      
DeletedYn bit 1      
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
*DeleteDate datetime 8      
*ZoneID nvarchar 10      
*QtyBase pDecimal 13      
*Unit nvarchar 5      
*UnitBase nvarchar 5      
*BOLNum nvarchar 255      
*Notes nvarchar max      
*ActivityType bit 1     0 = Move, 1 = Receive, 2 = Putaway, 3 = Pick, 4 = Ship, 5 = Adjust
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun        
CountDetailID bigint        
HeaderID bigint        
BatchID pBatchID        
ExtLocA int 4      
ExtLocAID nvarchar 10      
ExtLocB int 4      
ExtLocBID nvarchar 10      
LotNum pLotNum        
SerNum pSerNum        
QtyFrozen pDecimal 13      
QtyCounted pDecimal 13      
TagNum nvarchar 10      
NewExtLocAID nvarchar 10      
NewExtLocBID nvarchar 10      
QtyStatus smallint        
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun        
CountEntryID bigint        
BatchID pBatchID        
DetailID bigint        
ItemID pItemID        
LocID pLocID 10      
LotNum pLotNum        
SerNum pSerNum        
ExtLocA int 4      
ExtLocAID nvarchar 10      
ExtLocB int 4      
ExtLocBID nvarchar 10      
QtyCounted pDecimal 13      
CountUom pUom        
TagNum nvarchar 10      
Status tinyint        
EntryDate datetime 8      
UID pUserID        
HostID pWrkStnID        
ErrorFlag tinyint        
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
PostRun pPostRun        
ID bigint        
BatchID pBatchID        
ItemID pItemID        
LocID pLocID 10      
CountUom pUom        
CountUomConvFactor pDecimal 13      
ABCClass nvarchar 10      
CF xml -1      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 8      
LocID pLocID 10      
ZoneID nvarchar 10      
Description pDescription 25      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TranKey int 4      
ReqType smallint 2 -1    
ReqNum nvarchar 10      
DatePlaced datetime 8 getdate()    
DateNeeded datetime 8 getdate()    
LocID pLocID 10      
ShipToId pCustID 10      
ShipVia nvarchar 20      
ReqstdBy nvarchar 25      
CF xml -1      
ts timestamp 8      
Notes varchar max      
Status tinyint 1   Status 0 = Open, 1 = Completed
Column Name Column Type Length Default Value Description Enumeration
TranKey int 4      
LineNum int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
SerNum pSerNum 35      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
Qty pDecimal 13 0    
UOM pUom 5      
UnitCost pDecimal 13 0    
EntryDate datetime 8      
TransDate datetime 8      
GlPeriod smallint 2      
GlYear smallint 2      
QtySeqNum int 4      
QtySeqNum_Ext int 4      
HistSeqNum int 4      
HistSeqNumSer int 4      
CF xml -1      
ts timestamp 8      
Status tinyint 1   Status 0 = Unposted, 1 = Posted
*UnitCostACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
TranKey int 4      
LineNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
Qty pDecimal 13 0    
QtyFilled pDecimal 13 0    
UOM pUom 5      
UnitCost pDecimal 13 0    
GLAcctNum pGlAcct 255      
GLDescr pGLDesc 30      
QtySeqNum int 4      
QtySeqNum_Ext int 4      
LineSeq int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
HeaderId int 4      
LotNum pLotNum 16      
SerNum pSerNum 35      
Qty pDecimal 13 0    
QtyMoved pDecimal 13 0    
EntryDate datetime 8 getdate()    
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
MoveStatus tinyint   0   0 = Moving From, 1 = Moving To
MoveBy tinyint 1 0 Move By 0 = Item, 1 = Container
MoveById pItemID 24      
LocID pLocID 10      
ExtLocAFrom int 4      
ExtLocBFrom int 4      
ExtLocATo int 4      
ExtLocBTo int 4      
Qty pDecimal 13 0    
QtyMoved pDecimal 13 0    
UOM pUom 5      
EntryDate datetime 8 getdate()    
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
EntryDate datetime 8 getdate()    
ExtLocAFrom int 4      
ExtLocATo int 4      
ExtLocBFrom int 4      
ExtLocBTo int 4      
HostId pWrkStnID 20      
Id int 4      
LocID pLocID 10      
LotNum pLotNum 16      
MoveBy tinyint 1   Move By 0 = ItemId, 1 = ExtLocB
MoveById pItemID 24      
ParentId int 4      
Qty pDecimal 13      
SerNum pSerNum 35      
TransDate datetime 8 getdate()    
ts timestamp 8      
UID pUserID 20      
UOM pUom 5      
*FunctionID          
CF xml -1      
*PutawayReqID bigint        
Column Name Column Type Length Default Value Description Enumeration
Id int 4      
SeqNum int 4      
DtlSeqNum int 4      
BatchId pBatchID 6      
ItemId pItemID 24      
LocId pLocID 10      
QtyCounted pDecimal 13 0    
CountedUom pUom 5      
LotNum pLotNum 16      
SerNum pSerNum 35      
ExtLocAId nvarchar 10      
ExtLocBId nvarchar 10      
EntryDate datetime 8 getdate()    
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
BatchId pBatchID 6      
Description pDescription 35      
CountDate datetime 8 getdate()    
AssignedTo pEmpID 20      
PreparedDateTime datetime 8      
PreparedBy pUserID 20      
FrozenDateTime datetime 8      
FrozenBy pUserID 20      
LocId pLocID 10      
Filter nvarchar max      
DisplayFilter nvarchar max      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 8      
BatchId pBatchID 6      
LocId pLocID 10      
ExtLocAId nvarchar 10      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 8      
BatchId pBatchID 6      
ItemId pItemID 24      
LotNum pLotNum 16      
CostVariance pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
HeaderId bigint 8      
BatchId pBatchID 6      
ExtLocAId nvarchar 10      
ExtLocBId nvarchar 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
QtyFrozen pDecimal 13      
QtyCounted pDecimal 13      
TagNum int 4      
NewExtLocAId nvarchar 10      
NewExtLocBId nvarchar 10      
QtyStatus smallint 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 8      
BatchId pBatchID 6      
DetailId bigint 8      
ItemId pItemID 24      
LotNum pLotNum 16      
SerNum pSerNum 35      
ExtLocAId nvarchar 10      
ExtLocBId nvarchar 10      
QtyCounted pDecimal 13      
CountUom pUom 5      
TagNum int 4      
Status tinyint 1     0 = New; 1 = Verified; 2 = CountChanged; 3 = Deleted
EntryDate datetime 8      
UID pUserID 20      
HostId pWrkStnID 20      
ErrorFlag tinyint 1 0   0 = No Error
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 8      
BatchId pBatchID 6      
ItemId pItemID 24      
CountUom pUom 5      
CountUomConvFactor pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
PickKey int 4      
SourceId tinyint 1   Source Type 0 = Sales Order, 1 = Production Order, 2 = Work Order, 4 = WM Transfer, 8 = WM Material Requisition, 32 = PC Material Requisition
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
PickNum pInvoiceNum 15      
ItemId pItemID 24      
LocId pLocID 10      
SerNum pSerNum 35      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
UOM pUom 5      
QtyPicked pDecimal 13 0    
EntryDate datetime 8      
TransDate datetime 8      
GrpId int 4      
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
ts timestamp 8      
HistSeqNum int 4      
HistSeqNumSer int 4      
QtySeqNum int 4      
QtySeqNumExt int 4      
Status tinyint 1   Status 0 = New, 1 = Confirmed, 2 = Completed
*Type tinyint 1     0 = Pick, 1 = Move, 2 = Pack
*ExtLocATo int 4      
*ExtLocBTo int 4      
*PackNumber pInvoiceNum 15      
Column Name Column Type Length Default Value Description Enumeration
PickGenKey int 4      
SourceId tinyint 1   Source Type 0 = Sales Order, 1 = Production Order, 2 = Work Order, 4 = WM Transfer, 8 = WM Material Requisition, 32 = PC Material Requisition
TransId pTransID 8      
EntryNum int 4      
SeqNum int 4      
PickNum pInvoiceNum 15      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
UOM pUom 5      
QtyReq pDecimal 13 0    
ReqDate datetime 8      
Ref1 pTransID 8      
Ref2 pTransID 8      
Ref3 pTransID 8      
GrpId int 4      
OriCompQty pDecimal 13 0    
PickID nvarchar 20      
KitID pItemID 24      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Description varchar 50      
-*DisplayFilter nvarchar max      
-*Filter nvarchar max      
Id varchar 20      
-*Selected int 4      
ts timestamp 8      
CF xml -1      
*PickDate datetime 8      
*AssignedTo pEmpID 20      
*EntryDate datetime 8      
*LocID pLocID 10      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 20      
ParentId int 4      
LotNum pLotNum 16      
SerNum pSerNum 35      
Qty pDecimal 13      
UOM pUom 5      
EntryDate datetime 8      
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint 20      
LocID pLocID 10      
ItemID pItemID 24      
ExtLocAFrom int 4      
ExtLocBFrom int 4      
ExtLocATo int 4      
ExtLocBTo int 4      
Qty pDecimal 13      
UOM pUom 5      
EntryDate datetime 8      
TransDate datetime 8      
UID pUserID 20      
HostId pWrkStnID 20      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint 20      
ParentID bigint        
TransKey int        
TransType tinyint 1     0 = Receipt, 1 = Pick (for cancel orders)
TransId nvarchar 20      
EntryNum bigint        
ItemID pItemID 24      
LocID pLocID 10      
LotNum pLotNum        
ExtLocA int 4      
ExtLocB int 4      
UOM pUom 5      
SerNum pSerNum        
Source tinyint       0 = PO, 1 = WM Transfer Rcpt, 2 = MP Production Rcpt, 3 = WM Mat Req Ret, 4 = SO RMA, 5 = PC Mat Req Ret, 6 = SD Part Ret, 7 = SR Rcpt, 8 = SO, 9 = MP Production, 10 = SD, 11 = WM Transfer, 12 = WM Mat Req, 13 = PC Mat Req, 14 = PO Ret, 15 = SR
QtyReq pDecimal 13      
QtyFilled pDecimal 13      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
RcptKey int 4      
TransId pTransID 8      
EntryNum int 4      
ReceiptNum pInvoiceNum 15      
ItemId pItemID 24      
LocId pLocID 10      
SerNum pSerNum 35      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
UOM pUom 5      
Qty pDecimal 13 0    
Source tinyint 1 0 Source 0 = PO, 1 = Transfer, 2 = MP Production, 8 = WM Material Requisition Return, 16 = SO RMA, 32 = PC Material Requisition Return
ErrorFlag tinyint 1 0    
UID pUserID 20      
HostId pWrkStnID 20      
EntryDate datetime 8      
TransDate datetime 8      
CF xml -1      
ts timestamp 8      
HistSeqNum int 4      
HistSeqNumSer int 4      
QtySeqNum int 4      
QtySeqNumExt int 4      
Status tinyint 1   Status 0 = New, 1 = Confirmed, 2 = Completed, 3=Put Away
*BOLNum nvarchar 255      
*Notes nvarchar max      
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
BatchId pBatchID 6 '######'    
TransType tinyint 1   Transaction Type 31 = Increase, 32 = Decrease
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
Qty pDecimal 13 0    
Uom pUom 5      
UnitCost pDecimal 13 0    
EntryDate datetime 8 getdate()    
TransDate datetime 8 getdate()    
GLPeriod smallint 2      
GlYear smallint 2      
GLAcctOffset pGlAcct 255      
HistSeqNum int 4      
QtySeqNum int 4      
QtySeqNumExt int 4      
Cmnt nvarchar 35      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
TranKey int 4      
BatchID pBatchID 6      
Status tinyint 1 0 Status 0 = New, 1 = Picked, 2 = Completed
ItemId pItemID 24      
LocId pLocID 10      
LocIdTo pLocID 10      
LotNum pLotNum 16      
Qty pDecimal 13 0    
UOM pUom 5      
CostTransfer pDecimal 13 0    
EntryDate datetime 8      
TransDate datetime 8      
PackNum pTransID 8      
CF xml -1      
ts timestamp 8      
Cmnt varchar max      
-*QtySeqNum_OnOrd int 4      
-*QtySeqNum_Cmtd int 4      
*QuickTransferYn bit 1 0    
Column Name Column Type Length Default Value Description Enumeration
TranKey int 4      
TranPickKey int 4      
ItemId pItemID 24      
LocId pLocID 10      
SerNum pSerNum 35      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
Qty pDecimal 13 0    
UOM pUom 5      
UnitCost pDecimal 13 0    
EntryDate datetime 8      
TransDate datetime 8      
GlPeriod smallint 2      
GlYear smallint 2      
QOHSeqNum int 4      
QOHSeqNumExt int 4      
QOOSeqNum int 4      
HistSeqNum int 4      
HistSeqNumSer int 4      
CF xml -1      
ts timestamp 8      
Status tinyint 1   Status 0 = Unposted, 1 = Posted
*UnitCostACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
TranPickKey int 4      
TranRcptKey int 4      
ItemId pItemID 24      
LocId pLocID 10      
SerNum pSerNum 35      
LotNum pLotNum 16      
ExtLocA int 4      
ExtLocB int 4      
Qty pDecimal 13 0    
UOM pUom 5      
UnitCost pDecimal 13 0    
EntryDate datetime 8      
TransDate datetime 8      
GlPeriod smallint 2      
GlYear smallint 2      
QOHSeqNum int 4      
QOHSeqNumExt int 4      
HistSeqNum int 4      
HistSeqNumSer int 4      
CF xml -1      
ts timestamp 8      
Status tinyint 1   Status 0 = Unposted, 1 = Posted
*UnitCostACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
TransId int 4      
SeqNum int 4      
ItemId pItemID 24      
LocId pLocID 10      
LotNum pLotNum 16      
SerNum pSerNum 35      
ExtLocA int 4      
ExtLocB int 4      
CostUnit pDecimal 13 0    
CostUnitFgn pDecimal 13 0    
PriceUnit pDecimal 13 0    
PriceUnitFgn pDecimal 13 0    
HistSeqNum int 4      
Cmnt nvarchar 35      
CF xml -1      
ts timestamp 8      
*CostUnitACV pDecimal 13      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
EmployeeID pEmpID        
Password nvarchar max      
ScheduleID nvarchar 10      
LocID pLocID        
BatchId pBatchID        
ExtLocA int 4      
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
Id bigint        
UserID bigint 20      
FeatureID bigint        
CF xml -1      
ts timestamp 8      
Column Name Column Type Length Default Value Description Enumeration
ID bigint        
UserID bigint        
TaskCode nvarchar 10      
SkillLevel tinyint        
CF xml -1      
ts timestamp 8